package com.bsoft.gol.hbs.dao;

import ctd.persistence.annotation.DAOMethod;
import ctd.persistence.annotation.DAOParam;
import ctd.persistence.support.hibernate.HibernateSupportDelegateDAO;
import pcn.consultation.ReviewOpinionTemplate;

import java.util.List;

public abstract class ReviewOpinionTemplateDAO extends HibernateSupportDelegateDAO<ReviewOpinionTemplate> {

    public ReviewOpinionTemplateDAO() {
        this.setKeyField("opinionTemplateId");
    }

    @DAOMethod(sql = " from ReviewOpinionTemplate where opinionTypeId=:opinionTypeId and status = 1 ")
    public abstract List<ReviewOpinionTemplate> findOpinionTemplatebytypeId(@DAOParam("opinionTypeId")int opinionTypeId);

}
